Method 1: Back up SQL in mysql to import mysql Data to SQL Server. This method is suitable for scenarios with a small amount of data (you can consider how to avoid a large number of blob fields in your data or whether they do not exist ). Features:
The migration from MYSQL to oracle and the backup of bitsCN.com have been a program of the Yulin CPPCC in the past few days. due to the migration from MYSQL to Oracle, we have gained some experience.
Because the project was developed with MYSQL at
Java inserts mysql binary files and blob types. Problems and Solutions: bitsCN.com is the first thing to prepare for database creation:
We need to set the binary field to the Blob type, and select the appropriate Blob type based on the file size.
Mysql inserts binary files and blob types. Problems and Solutions
Mysql inserts binary files and blob types. Problems and Solutions
The first step is to prepare a database:
We need to set the binary field to the Blob type, and select the
The first step is to prepare a database:
We need to set the binary field to the Blob type, and select the appropriate Blob type based on the file size. The following figure shows the size of each Blob type that can accommodate binary files.
Four
The first step is to prepare a database:We need to set the binary field to the Blob type, and select the appropriate Blob type based on the file size. The following figure shows the size of each Blob type that can accommodate binary files.Four BLOB
1, using the tool class and its configuration file method, connected to the background of the database"Pros: You can connect to different databases and set the type of the database individually""Disadvantage: The database operation of the SQL
Atitit. Mssql SQL server converts mysql and paging SQL ast, atitit. mssqlast
Atitit. Mssql SQL server converts mysql and sets up paging SQL ast
1. Major conversions: Function Conversion, paging conversion 1
2. Idea: mssql SQL> ast> mysql 1
3. SQL
Atitit. MSSQL SQL Server conversion MySQL and paging SQL AST build1. Main conversions :: function Conversion , paging conversion 12. Ideas :: MSSQL SQL >>ast>>mysql 13. the main SQL is as follows ::: 14. Mssql2mysqlconvertor (proj:wechatadm4propt 2
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.